User Roles: Any user with Reporting Tool installed on PC
Last Updated: Dec 14, 2011 10:06 am
The new Reporting Tool application includes a SQL Logging feature that allows you to view the SQL statements used to generate Standard Reports and Letters.
How To Use Feature
Click the Turn On SQL Logging button on the Settings tab.
The following dialog box displays.
Then:
- Run a report or letter.
- Go to the My Documents > SQL folder.
- Find the correct file by date.
- Right-click on the file name and select Open With > Notepad (or another text editor).
- Enable Word Wrap (Format > Word Wrap in Notepad).
Notes
- Every SQL that runs while SQL Logging is turned on will be captured in the log (including SQLs used to populate drop-down lists on the Selection Criteria panel).
- Each SQL statement begins with a date/time stamp (e.g., /*6/4/2010 1:10:12 P.M.*/).
- The most recent SQL statement appears at the bottom of the log.
- SQL statements that display in the log are used to generate the raw data for a report. Reports often include business logic that performs other functions (grouping, removing duplicates, calculations, etc.)